UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pMJegC1a9zESON+aJbWspTj3y+v/BPRLk2QXG3U4mU='
WHERE
key_id = 'b32157292d992b3ef7af8651a0a7ec12660c38a9fb9b8223579e9b3dc57a0a70'
AND (
token = '9pMJegC1a9zESON+aJbWspTj3y+v/BPRLk2QXG3U4mU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)