UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3bmDJGZlILF6K2GZ0saWCUdMxaotga8Xrj0YDkgR4PY='
WHERE
key_id = '8ad9a47aecf1ae6b6d690810f71ee11de9b08db3ccd545eb7854677d6d4af224'
AND (
token = '3bmDJGZlILF6K2GZ0saWCUdMxaotga8Xrj0YDkgR4PY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)