UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kSU9j0ryD+vX98XN2N9bbgiZczJhkM8q3DjsN+DUwiA='
WHERE
key_id = 'e4b7ae47f803f4e8952185d00dd4f811def1d1c074588a0b844365fbbeadb5ae'
AND (
token = 'kSU9j0ryD+vX98XN2N9bbgiZczJhkM8q3DjsN+DUwiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)