UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ONbTHlsm7jlNPqD7znr7/OruGlKLAE7Vr6hmG/XbYtY='
WHERE
key_id = '42fc37091d2283c7195124b3f3b35f19fc453675b9179c68e22944a45c75a13a'
AND (
token = 'ONbTHlsm7jlNPqD7znr7/OruGlKLAE7Vr6hmG/XbYtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)