UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tzfbEtS5ZHtu+JzTepzGqf+fIEOPmG24eWXU604RBFU='
WHERE
key_id = 'c0fee09ed5eebd0de0f545d94f73a0896daec6480eec99af4e82a42eee5adf10'
AND (
token = 'tzfbEtS5ZHtu+JzTepzGqf+fIEOPmG24eWXU604RBFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)