UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bJZIk17yi/bYVcL+9Z/1MoBrCpXt2CWMulgSwyUWD/A='
WHERE
key_id = 'bde865a541577a67f828d469a071c3bc7a50b147d208ed07efb6f65f12eadadf'
AND (
token = 'bJZIk17yi/bYVcL+9Z/1MoBrCpXt2CWMulgSwyUWD/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)