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