UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6jo2FYIrIm5tFEdkr58I7UlFx8+Hlhwf7lTbHsi9ZHE='
WHERE
key_id = '3e6049b7441c0660a8a756fe39becfa933ee65fa0e2a58fccd7fd74971944af5'
AND (
token = '6jo2FYIrIm5tFEdkr58I7UlFx8+Hlhwf7lTbHsi9ZHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)