UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1fgBsM5iK7idVReA05YjGRwaghOIiYp3srSWCRSuWzM='
WHERE
key_id = '7d76091496488bbb93524cb992b359e7270e37e14831071826cd140edfa1fbb9'
AND (
token = '1fgBsM5iK7idVReA05YjGRwaghOIiYp3srSWCRSuWzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)