UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K1RwHgYARGJyjyoSXPlp5k9GQZ2gTSoJUX3Wjs+8m64='
WHERE
key_id = 'f6e7a7c6d879b81fe5e7656280cd0563616bf0afab934df78750b4168ff939ab'
AND (
token = 'K1RwHgYARGJyjyoSXPlp5k9GQZ2gTSoJUX3Wjs+8m64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)