UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PRkWLtZaMU5vJnvuLx/gSy5nMeURfIh+oWwqd0KfS2s='
WHERE
key_id = 'c8a7bc73b7f7988570e0364010830ef644558e8b1afedeebdbb3af0be4d81185'
AND (
token = 'PRkWLtZaMU5vJnvuLx/gSy5nMeURfIh+oWwqd0KfS2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)