UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x2W3c1bZePI7JCWpDwpVUbHOVI7mqdy7FKdCrYwIiCw='
WHERE
key_id = '9d1e5ebbe2a92d702c9a863bcd729f6a65989da1b1181702f4cf76b0e7462cb1'
AND (
token = 'x2W3c1bZePI7JCWpDwpVUbHOVI7mqdy7FKdCrYwIiCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)