UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D0Zs3E6cV0+iptkOs4wsf5d1ycHWjmO1GvhcuRrDkpM='
WHERE
key_id = 'cfc3f33fa5bd7be857a45efff4c206c9794aac11c455272fcd4f7392fa4f119f'
AND (
token = 'D0Zs3E6cV0+iptkOs4wsf5d1ycHWjmO1GvhcuRrDkpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)