UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zczlF0qtDf+h3xmZgjEAhH5ZSpgKZyqVvFdZ5EkETtg='
WHERE
key_id = '19942c1db7d690c68530b57c384b8ae3f746446aedb88f0f4ee996e1016678b1'
AND (
token = 'zczlF0qtDf+h3xmZgjEAhH5ZSpgKZyqVvFdZ5EkETtg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)