UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/OehTpxLvOLnXXEKnP9xZeFbq1yYgEXNCM5r9wD/Bpw='
WHERE
key_id = '6978c06b3c3e82296f2f66b706960294859933bd12ed1682bebecd32372a2baa'
AND (
token = '/OehTpxLvOLnXXEKnP9xZeFbq1yYgEXNCM5r9wD/Bpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)