UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GVW0mROVVvlcAAr7Y4yallPn0w9rlGMjUqwyxneB6Y='
WHERE
key_id = '15b0e29ca63d59cc5d162e63ac102315993180d7a07af54f136aea23bd85f115'
AND (
token = '6GVW0mROVVvlcAAr7Y4yallPn0w9rlGMjUqwyxneB6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)