UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BnJXn/R2uUUceCl844fcaUbScLaZNvas/oyRVT7Qsac='
WHERE
key_id = '06946e5c8429b952ce72ca591c28a869e84da00955e9b8a75a9524ee30a44832'
AND (
token = 'BnJXn/R2uUUceCl844fcaUbScLaZNvas/oyRVT7Qsac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)