UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5pjBCn4W5rx7dbzyiqNyZbNBrL3JeMf+sVJ7OkmKoho='
WHERE
key_id = '7b249458f8a5e819f91724b4ec9ad670224a09a0abd7a7707dcb86e2a580fd33'
AND (
token = '5pjBCn4W5rx7dbzyiqNyZbNBrL3JeMf+sVJ7OkmKoho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)