UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3F8TcbRx4keyBrXIUi6AAgU2Yrv6Lf4d27/r9Lu8WgI='
WHERE
key_id = 'a1831d7372eee184e0fc780c22b9f5ca5699c799151a86ca0febb650b5c4d07d'
AND (
token = '3F8TcbRx4keyBrXIUi6AAgU2Yrv6Lf4d27/r9Lu8WgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)