UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6xIK8H6bcp2Yplg598WcFCnEzMhtwoO/Rf3M1OUjsA='
WHERE
key_id = '239844c853c7586c5ca7f1c74bbc80f2499ff153d427c36ea1c831010c14784b'
AND (
token = 'N6xIK8H6bcp2Yplg598WcFCnEzMhtwoO/Rf3M1OUjsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)