UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RVDYJ9tRj5kJ2wQD3yaHRZ1pMWJ1G6lA/6gFOrqYUB8='
WHERE
key_id = 'e1f15e687c865886b772f63e2def87f53296aede1f2243f376938a40c811bbce'
AND (
token = 'RVDYJ9tRj5kJ2wQD3yaHRZ1pMWJ1G6lA/6gFOrqYUB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)