UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k1pYEqcmiDlsJBqX+4BlkJ5CcfxMwdXpmFENLTB6LDQ='
WHERE
key_id = '8af7c8d5a11d4537c581fd8cc90499a5e9fc2ef1221c4ccf5e6b563bb94a5d69'
AND (
token = 'k1pYEqcmiDlsJBqX+4BlkJ5CcfxMwdXpmFENLTB6LDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)