UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qA997FIGtxyo0F8ZvQcbjlLb6FXS1YDIqHfVi15FZ4g='
WHERE
key_id = '0a0d89bb4ede238e6428db3521b30d80e5c5ebc2108f5c5e1bcb6c33efbfb1de'
AND (
token = 'qA997FIGtxyo0F8ZvQcbjlLb6FXS1YDIqHfVi15FZ4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)