UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hac1keLGZx3fi5n1KwIk77Nx6gdzybi2dWlyBfK5TUs='
WHERE
key_id = 'deed9440cbf59ab8c6a2097880c3adf2e1103ec526b28ee6f237588eccd3f5ba'
AND (
token = 'hac1keLGZx3fi5n1KwIk77Nx6gdzybi2dWlyBfK5TUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)