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