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