UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MKg7H7DNGHq6pprHtz4J9vlDxR0woNOBKTeX95YnFNs='
WHERE
key_id = '2babec2ab28f7c884505de360647ace05fb866cb38017b54dbea6e5ebc3be767'
AND (
token = 'MKg7H7DNGHq6pprHtz4J9vlDxR0woNOBKTeX95YnFNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)