UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X6IlaaG7cGGtHiiRu/QDsyUPe5iaLK51s1pUfwMuz3A='
WHERE
key_id = 'a85693a3b141d3d05be56b4ee9433baf7f1e73330d8043c6c53839a5e34f755c'
AND (
token = 'X6IlaaG7cGGtHiiRu/QDsyUPe5iaLK51s1pUfwMuz3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)