UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kq9Wwzfb2CZpnrcfWvvnFz43M0qCk5/RVGlCzq404bg='
WHERE
key_id = 'e4b55b15b5e14cdcb3cb3e619c3c56930577808df864f8941e95f88ef9d70800'
AND (
token = 'kq9Wwzfb2CZpnrcfWvvnFz43M0qCk5/RVGlCzq404bg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)