UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o931uE7VjMrE9/USWqLun19YYgLJL5OyeXgkr3ImXsA='
WHERE
key_id = 'c48930f1a0521e75065eabb25e615abc30c85c939f6bb19927843084d9d5f667'
AND (
token = 'o931uE7VjMrE9/USWqLun19YYgLJL5OyeXgkr3ImXsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)