UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6p8Ba+Kk6TsRIfXr3xTYfWyye3O6Z9E+uGUNcucIEU='
WHERE
key_id = 'dfb6c57fff55320abc8ccbe7cc31203d666d102592dc42e4167f81a987c9b813'
AND (
token = 'p6p8Ba+Kk6TsRIfXr3xTYfWyye3O6Z9E+uGUNcucIEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)