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