UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hWMsWhTWupQbm0AaGUWPqeAbBLUd01sH5cY6Kf8jGmM='
WHERE
key_id = '6a65430478cb11adfb98bd6fe013808747a1f7d68428d58c000e561c4f0ffe26'
AND (
token = 'hWMsWhTWupQbm0AaGUWPqeAbBLUd01sH5cY6Kf8jGmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)