UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/PzX46QWbcXjJiyJUdIs5QFeLhMY35PmmRXEETHHNvk='
WHERE
key_id = '1b707d3801ffae2d472b7136478fd6a32b3ad437a9abbdca6ebe6a5971194268'
AND (
token = '/PzX46QWbcXjJiyJUdIs5QFeLhMY35PmmRXEETHHNvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)