UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NZ0UBd+tG/zKQGT1ysdTwkhaNQkUQOP3GWVbCHX5QYw='
WHERE
key_id = '8a92ef8db1a7243a50da9e546eed0bdea7eece5c12b56a9f3606d0af6771f2ca'
AND (
token = 'NZ0UBd+tG/zKQGT1ysdTwkhaNQkUQOP3GWVbCHX5QYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)