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