UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mmFYU3ecVK6nHjQk8BjCBCuP6XzJa3I0UW77mTGXWOs='
WHERE
key_id = '0aea840437572ed3ae14a1d70786bc9d8419d94836d5d56a9b2ab3b1d0b5b398'
AND (
token = 'mmFYU3ecVK6nHjQk8BjCBCuP6XzJa3I0UW77mTGXWOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)