UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bDpUgy0AULD0GFUWHu8vaJc0RaSaYZaxhXyndzpHD7E='
WHERE
key_id = 'e6f163f6dab0fdf78b0ea020f77a436d4537ee93b35e7510290bedd88a674861'
AND (
token = 'bDpUgy0AULD0GFUWHu8vaJc0RaSaYZaxhXyndzpHD7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)