UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L7CtgwzTj3VhtaF0wHm3nl4CK3IrbYjCiSP9wNg5qyk='
WHERE
key_id = 'adab88914a0bd79904656ed8b5017ad0c31ee46ce734323bdb7be76df98b3256'
AND (
token = 'L7CtgwzTj3VhtaF0wHm3nl4CK3IrbYjCiSP9wNg5qyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)