UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h0xFVjMxVU5Vl1h6cx0AY/CXs5XppHYRoNgCc9RXKgA='
WHERE
key_id = 'c29d3500252cd04abf0820c7dd11c41bd823219c4fe365039330b25c343e3c50'
AND (
token = 'h0xFVjMxVU5Vl1h6cx0AY/CXs5XppHYRoNgCc9RXKgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)