UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6pAuBR3vSXzz19ttcfho7vg7gA2mz9xBVfxH8iwn4/Y='
WHERE
key_id = '9aab3c5a4b6151faf1c217090b9e19d419fb30cad52e76569df4908e1a1192f1'
AND (
token = '6pAuBR3vSXzz19ttcfho7vg7gA2mz9xBVfxH8iwn4/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)