UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XvIKpu/TpgMS6kro4g6LL0A0nISG8hNeaFm+YTjRMGs='
WHERE
key_id = 'b484c925805263bb6f37e26ddc731ec55ed0545708f53535a32d6f2c4fb4bee1'
AND (
token = 'XvIKpu/TpgMS6kro4g6LL0A0nISG8hNeaFm+YTjRMGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)