UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VAL9vBMz0w+TV4sgb9rzKlm9f7RfP3ZCeZ8E59Pr4Ag='
WHERE
key_id = '2d508c3b81605eb1c83525c16799c0f465a8032c5fca902dcefc819050bfdf8a'
AND (
token = 'VAL9vBMz0w+TV4sgb9rzKlm9f7RfP3ZCeZ8E59Pr4Ag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)