UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pJA+1r3QIhblTZon0uiocyFlzxYj+P4nI2gDbWmPXA='
WHERE
key_id = 'e8a8d4d19597c9246e7aa7e9e8c43aff38d24b63e6f880a33b89975da2d419bc'
AND (
token = '8pJA+1r3QIhblTZon0uiocyFlzxYj+P4nI2gDbWmPXA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)