UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0vs+YT7RgCnR9N5JdOkfLETozqbpSU8XMKK2OaTePS4='
WHERE
key_id = 'bf4b37e2cebb6d2d2127e98b172d2ea215bb4d8a6acb8284dc097c4003aae77c'
AND (
token = '0vs+YT7RgCnR9N5JdOkfLETozqbpSU8XMKK2OaTePS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)